//城市信息SQL查询模块
/*
  提供城市指标信息的SQL查询语句
*/

//导出当前模块中定义的SQL查询对象
module.exports={
  //1-查询综合得分
  CompreScoreQuery:{
      queryScoreByCityName:"SELECT * FROM totalscore WHERE cityName = ?"
  },
  //2-查询基本指标
  BasicIndexQuerybyCityName:{
    //2007年基本指标  
    queryBasicIndexByCityNameOf2007:"SELECT * FROM year_2007 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2008:"SELECT * FROM year_2008 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2009:"SELECT * FROM year_2009 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2010:"SELECT * FROM year_2010 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2011:"SELECT * FROM year_2011 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2012:"SELECT * FROM year_2012 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2013:"SELECT * FROM year_2013 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2014:"SELECT * FROM year_2014 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2015:"SELECT * FROM year_2015 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2016:"SELECT * FROM year_2016 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2017:"SELECT * FROM year_2017 WHERE cityName= ?",
    queryBasicIndexByCityNameOf2018:"SELECT * FROM year_2018 WHERE cityName= ?",
  }
}